# Run in phpMyAdmin or Whatever You're Using to Reach your Database Panel:
ALTER TABLE `users` ADD `oauth_identifier` VARCHAR(255) NOT NULL AFTER `registration_source`;

// Guest Ticketing is Disabled by Default, Replace '0' with '1' to Enable it:
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'sp_guest_ticketing', '0');

INSERT INTO `email_templates` (`id`, `title`, `subject`, `hook`, `language`, `template`, `is_built_in`, `updated_at`, `created_at`) VALUES (NULL, 'Ticket Created by Guest', 'New Guest Ticket Created', 'ticket_created_guest', 'english', '<p>Dear Customer,<br><br>We have received a ticket submission request and a guest ticket has been successfully created for you.<br><br>Please kindly verify that the request was submitted by you, otherwise, you will not be able to add the replies: <a href=\"{EMAIL_LINK}\" target=\"_blank\">Verify Now</a><br><br>You can access it by clicking: <a href=\"{TICKET_URL}\" target=\"_blank\">View Ticket</a><br><br>If you didn\'t submit it, please kindly ignore this email (possibly the email address typing mistake).<br><br>Regards,<br>{SITE_NAME} Support</p>', '1', NULL, '1660817123');
INSERT INTO `email_templates` (`id`, `title`, `subject`, `hook`, `language`, `template`, `is_built_in`, `updated_at`, `created_at`) VALUES (NULL, 'Resend Ticket Access', 'Re-sent Guest Ticket Access URL', 'resend_ticket_access', 'english', '<p>Dear Customer,<br><br>We have resent the URL of your guest ticket #{TICKET_ID}.<br><br>You can access that ticket by clicking on the following link:<br><a href=\"{TICKET_URL}\" target=\"_blank\">Click here</a><br><br>Regards,<br>{SITE_NAME} Support</p>', '1', NULL, '1660931621');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'i_pc_string', '');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'i_pc_status', '0');
INSERT INTO `settings` (`id`, `access_key`, `value`) VALUES (NULL, 'i_at', '1660930217');
ALTER TABLE `tickets` ADD `is_verified` TINYINT UNSIGNED NULL DEFAULT NULL AFTER `email_address`;
ALTER TABLE `tickets` ADD `email_attempts` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `is_verified`;
ALTER TABLE `tickets` ADD `last_email_attempt` INT UNSIGNED NULL AFTER `email_attempts`;
UPDATE `tickets` SET `is_verified` = 1 WHERE `is_verified` IS NULL;